Problem Note 45266: Visual totals might be incorrect when single member on slicer and two hierarchies from the same dimension are on different axes
 |  |  |  |  |
When a SAS® OLAP cube has multiple hierarchies defined for a dimension, referencing more than one of the hierarchies in that dimension in your OLAP query might return incorrect visual totals.
Specifically, if one of the hierarchies is on the slicer and another hierarchy from the same dimension is on one of the axes, then filtering on a single member on the slicer might return incorrect visual totals. If you are displaying parent totals, then the correct values should be returned.
Visual totals are correct in the following circumstances:
- You filter on more than one member on the slicer, while still having hierarchies from the same dimension on the slicer and another axis.
- You filter on a single member value on an axis instead of the slicer, with another hierarchy from the same dimension on the slicer.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | N/A | z/OS | 9.1 TS1M2 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M2 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M2 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M2 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.1 TS1M2 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M2 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M2 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M2 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Linux | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M2 | 9.3 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.1 TS1M2 | 9.3 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M2 | 9.3 TS1M0 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#45266| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2012-03-28 08:52:56 |
| Date Created: | 2012-01-03 12:38:00 |